<If Loop>
   <IsFKey>
--***********************************************************
--SELECT Stored Procedure for <Table> <RTable> table
--***********************************************************
GO

USE <Database>
GO

IF EXISTS (SELECT sys.objects.name FROM sys.objects INNER JOIN sys.schemas ON sys.objects.schema_id = sys.schemas.schema_id WHERE sys.objects.name = '<TableU>_<RTableU><MiscTag>Select'  and sys.schemas.name = '<Owner>'  and sys.objects.type = 'P') 
DROP PROCEDURE [<Owner>].[<TableU>_<RTableU><MiscTag>Select] 
GO

CREATE PROCEDURE [<Owner>].[<TableU>_<RTableU><MiscTag>Select]
AS 
BEGIN 
SELECT
   <IsFKey>
     [<RField>]
   <IsFKey>
   <And>
   <IsRDisplayField>
    ,[<RDisplayField>]
   <IsFKey>
FROM 
     [<ROwner>].[<RTable>]
   <IsFKey>
END 
GO

GRANT EXECUTE ON [<Owner>].[<TableU>_<RTableU><MiscTag>Select] TO [Public]
GO


</If Loop>
